﻿using ERP_RORZE_DLL.Product.Base;
using System;using ERP_RORZE_SYSTEM;
using System.Collections.Generic;
using System.Data;using ERP_RORZE_SYSTEM;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ERP_RORZE_DLL.Product.DAO
{
    public class ClsMachineDAO: ExecuteSQL
    {
        ExecuteSQL Execute = new ExecuteSQL();

        public DataTable GetAllMachine()
        {
            string sql = clsConstantsFuction.ClsFuctionMachine.GetAllMachine;
            return Execute.DoStoreProcedure(sql, true);
        }
        public DataTable GetAllMachineGroup()
        {
            string sql = clsConstantsFuction.ClsFuctionMachine.GetAllMachineGroup;
            return Execute.DoStoreProcedure(sql, true);
        }

        public DataTable GetAllMachineDailyTime()
        {
            string sql = clsConstantsFuction.ClsFuctionMachine.RMachineDailyTime_CrosstabAll;
            return Execute.DoStoreProcedure(sql, true);
        }

        public void Dostoreprocedure(string store)
        {
            Execute.DoStore(store, true);
        }
    }
}
